package com.purplesoft.zettl.DatabaseTables;

import android.provider.BaseColumns;

public class TblCart {

	public class Columns implements BaseColumns {
		// columns of table "tblCart"
		public static final String ItemID = "ItemID";
		public static final String Amount = "Amount";
		public static final String ListID = "ListID";
		public static final String Created = "Created";
		public static final String Modified = "Modified";
	}

	// table name
	public static final String tableName = "tblCart";

	// SQL command to create table "tblCart"
	public static final String createTable = "CREATE TABLE " + tableName + "("
			+ Columns._ID + " INTEGER PRIMARY KEY AUTOINCREMENT, "
			+ Columns.ItemID + " TEXT, " 
			+ Columns.Amount + " REAL, "
			+ Columns.ListID + " INTEGER, "
			+ Columns.Created + " TEXT, "
			+ Columns.Modified + " TEXT)";

}
